DETALLE_VISITAS

"192.168.0.1:sipop"

DETALLE_VISITAS

Descriptions

DETALLE DE UNA VISITA REALIZADA

Fields

Name	Data type	Description
ID_DETALLEVISITA	CHAR (8)	ID de la tabla
COD_EXPEDIENTE	CHAR (8)	ID de la Tabla expediente
COD_TECNICO	CHAR (8)	Identifica el tecnico que atiende
FECHA	DATE	Fecha de la Visita
ANOTACIONES	VARCHAR (300)	Anotaciones realizadas por el técnico

Triggers

There are no triggers for table DETALLE_VISITAS

Indices

Index	Fields	Active	Unique	Order
PK_DETALLE_VISITAS	ID_DETALLEVISITA			Ascending

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
EXPEDIENTE	INTEG_129	COD_EXPEDIENTE	ID_EXPEDIENTE	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table DETALLE_VISITAS

Definition


CREATE TABLE DETALLE_VISITAS (
    ID_DETALLEVISITA CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    COD_EXPEDIENTE CHAR (8) CHARACTER SET NONE COLLATE NONE,
    COD_TECNICO CHAR (8) CHARACTER SET NONE COLLATE NONE,
    FECHA DATE,
    ANOTACIONES VARCHAR (300) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE DETALLE_VISITAS ADD CONSTRAINT PK_DETALLE_VISITAS PRIMARY KEY (ID_DETALLEVISITA);
ALTER TABLE DETALLE_VISITAS ADD  FOREIGN KEY (COD_EXPEDIENTE) REFERENCES EXPEDIENTE (ID_EXPEDIENTE);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.